<?php

use yii\db\Migration;

class m240108_234139_diandi_place_room extends Migration
{
    public function up()
    {
        /* 取消外键约束 */
        $this->execute('SET foreign_key_checks = 0');
        
        /* 创建表 */
        $this->createTable('{{%diandi_place_room}}', [
            'id' => "int(11) NOT NULL AUTO_INCREMENT",
            'bloc_id' => "int(11) NULL DEFAULT '0' COMMENT '公司ID'",
            'store_id' => "int(11) NULL COMMENT '商户ID'",
            'hotel_id' => "int(11) NULL DEFAULT '0' COMMENT '酒店ID'",
            'type_id' => "int(11) NULL COMMENT '房源类型，酒店，民宿，公寓等'",
            'title' => "varchar(255) NULL DEFAULT '' COMMENT '房间名称'",
            'floor' => "varchar(255) NULL",
            'bed_guest' => "varchar(255) NULL",
            'tier_id' => "int(11) NULL COMMENT '楼层'",
            'unit_id' => "int(11) NULL COMMENT '单元'",
            'thumb' => "varchar(255) NULL DEFAULT '' COMMENT '房间主图'",
            'oprice' => "decimal(11,2) NULL DEFAULT '0.00' COMMENT '原价'",
            'cprice' => "decimal(11,2) NULL DEFAULT '0.00' COMMENT '现价'",
            'mprice' => "decimal(11,2) NULL DEFAULT '0.00' COMMENT '会员价'",
            'thumbs' => "text NULL COMMENT '房间相册'",
            'device' => "text NULL COMMENT '服务设施'",
            'room_pid' => "int(11) NULL DEFAULT '0' COMMENT '主房ID'",
            'is_suite' => "int(11) NULL DEFAULT '0' COMMENT '是否是套房'",
            'area' => "decimal(11,2) NULL COMMENT '面积'",
            'room_num' => "int(11) NULL COMMENT '几室'",
            'toilet_num' => "int(11) NULL COMMENT '几卫'",
            'bed_children' => "int(11) NULL COMMENT '儿童床位数'",
            'bed_adult' => "int(11) NULL COMMENT '成人床位数'",
            'bed' => "int(11) NULL COMMENT '床位数'",
            'cleaning_fee' => "decimal(11,2) NULL DEFAULT '0.00' COMMENT '清洁费'",
            'server_fee' => "decimal(11,2) NULL COMMENT '服务费'",
            'persons' => "int(11) NULL DEFAULT '0' COMMENT '最多容纳人数'",
            'bedadd' => "varchar(30) NULL DEFAULT '' COMMENT '是否可加床'",
            'status' => "int(11) NULL DEFAULT '0' COMMENT '房间状态'",
            'isshow' => "int(11) NULL DEFAULT '0' COMMENT '是否显示'",
            'sales' => "text NULL COMMENT '销售数量'",
            'displayorder' => "int(11) NULL DEFAULT '0' COMMENT '排序'",
            'area_show' => "int(11) NULL DEFAULT '0' COMMENT '是否显示具体位置'",
            'floor_show' => "int(11) NULL DEFAULT '0' COMMENT '是否显示楼层'",
            'smoke_show' => "int(11) NULL DEFAULT '0' COMMENT '是否显示抽烟'",
            'bed_show' => "int(11) NULL DEFAULT '0' COMMENT '是否添加床位'",
            'persons_show' => "int(11) NULL COMMENT '是否显示添加人数'",
            'bedadd_show' => "int(11) NULL DEFAULT '0' COMMENT '是否显示添加床位'",
            'score' => "int(11) NULL DEFAULT '0' COMMENT '订房积分'",
            'breakfast' => "tinyint(3) NULL DEFAULT '0' COMMENT '0无早 1单早 2双早'",
            'language' => "tinyint(4) NOT NULL DEFAULT '0' COMMENT '语言类型标志/默认中文0'",
            'free_cancel' => "tinyint(4) NULL DEFAULT '0' COMMENT '是否免费取下1是0否'",
            'checkin_start' => "varchar(30) NULL COMMENT '入住开始时间'",
            'checkin_end' => "varchar(30) NULL COMMENT '入住结束时间'",
            'cancel_start' => "varchar(30) NULL COMMENT '取消开始时间'",
            'cancel_end' => "varchar(30) NULL COMMENT '退房结束时间'",
            'out_time' => "datetime NULL COMMENT '最后离店时间'",
            'time_length' => "int(11) NULL COMMENT '租约类型：时间，月，天，年'",
            'time_type' => "int(11) NULL DEFAULT '0' COMMENT '租期:1长租2短租'",
            'lease_type' => "int(11) NULL DEFAULT '0' COMMENT '1整租 2合租'",
            'desc' => "varchar(255) NULL COMMENT '房间介绍'",
            'content' => "text NULL COMMENT '房间详情'",
            'remark' => "text NULL COMMENT '备注'",
            'room_type' => "int(11) NULL COMMENT '全局房型'",
            'room_type_id' => "int(11) NULL DEFAULT '0' COMMENT '房型id'",
            'landlord_id' => "int(11) NULL COMMENT '房东'",
            'comment_num' => "int(11) NULL DEFAULT '0' COMMENT '评价数量'",
            'comment_start' => "decimal(11,2) NULL DEFAULT '5.00' COMMENT '评价星级'",
            'PRIMARY KEY (`id`)'
        ], "ENGINE=MyISAM  DEFAULT CHARSET=utf8");
        
        /* 索引设置 */
        $this->createIndex('indx_hotelid','{{%diandi_place_room}}','hotel_id',0);
        
        
        /* 表数据 */
        $this->insert('{{%diandi_place_room}}',['id'=>'1','bloc_id'=>'38','store_id'=>'2','hotel_id'=>'106','type_id'=>'23','title'=>'昆仑金','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'218','unit_id'=>NULL,'thumb'=>'202312/14/4356f47d-b6bd-3493-9812-b5bf96f4b9f6.jpg','oprice'=>'2.00','cprice'=>'2.00','mprice'=>'2.00','thumbs'=>'a:2:{i:0;s:50:"202312/14/8db79d92-0b00-3980-9e30-c90ac7d06d11.jpg";i:1;s:50:"202312/14/fa77dc34-b86f-32b1-a27e-163a10bdff11.jpg";}','device'=>'','room_pid'=>'0','is_suite'=>'0','area'=>'2.00','room_num'=>'11','toilet_num'=>'1','bed_children'=>'2','bed_adult'=>'2','bed'=>'4','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'2','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'11','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'14:11:42','checkin_end'=>'15:11:42','cancel_start'=>'14:11:43','cancel_end'=>'15:11:43','out_time'=>'0000-00-00 00:00:00','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'房间简介','content'=>'<p>房间详情<br/></p>','remark'=>'','room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'2','bloc_id'=>'38','store_id'=>'2','hotel_id'=>'106','type_id'=>'23','title'=>'昆仑木','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'218','unit_id'=>NULL,'thumb'=>'202312/14/2b6fe089-0c97-39f3-bf63-9cb2dcaf70cd.jpg','oprice'=>'2.00','cprice'=>'2.00','mprice'=>'2.00','thumbs'=>'a:1:{i:0;s:50:"202312/14/6eb7d014-5cc8-37bc-a359-e4483623be3a.jpg";}','device'=>'','room_pid'=>'0','is_suite'=>'0','area'=>'2.00','room_num'=>'11','toilet_num'=>'1','bed_children'=>'2','bed_adult'=>'2','bed'=>'4','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'2','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'11','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'14:11:42','checkin_end'=>'15:11:42','cancel_start'=>'14:11:43','cancel_end'=>'15:11:43','out_time'=>'0000-00-00 00:00:00','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'房间简介','content'=>'<p>房间详情</p>','remark'=>'','room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'3','bloc_id'=>'38','store_id'=>'2','hotel_id'=>'106','type_id'=>'23','title'=>'演示房间1','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'219','unit_id'=>NULL,'thumb'=>'202312/14/f162d6df-0439-3162-8424-0135d092af86.jpg','oprice'=>'2.00','cprice'=>'2.00','mprice'=>'2.00','thumbs'=>'a:2:{i:0;s:50:"202312/14/b3f6cea4-4ed5-3750-8a2c-bf8065084153.jpg";i:1;s:50:"202312/14/be6aec7d-45cf-373e-8634-2674e6d633bb.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'2.00','room_num'=>'1','toilet_num'=>'2','bed_children'=>'2','bed_adult'=>'2','bed'=>'4','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'1','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'44','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'4','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'14:08:25','checkin_end'=>'15:08:25','cancel_start'=>'14:08:27','cancel_end'=>'15:08:27','out_time'=>'0000-00-00 00:00:00','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'4','content'=>'','remark'=>NULL,'room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'4','bloc_id'=>'38','store_id'=>'2','hotel_id'=>'106','type_id'=>'23','title'=>'演示房间2','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'219','unit_id'=>NULL,'thumb'=>'202312/14/4dd324aa-a862-3dd5-8bdb-b8417cad0bab.jpg','oprice'=>'2.00','cprice'=>'2.00','mprice'=>'2.00','thumbs'=>'a:2:{i:0;s:50:"202312/14/18fb8b73-6395-3780-821c-8c80340521c0.jpg";i:1;s:50:"202312/14/e5d76005-3303-3e71-9301-27df190f6ed9.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>'2.00','room_num'=>'11','toilet_num'=>'1','bed_children'=>'2','bed_adult'=>'2','bed'=>'4','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'11','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'11','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'14:09:04','checkin_end'=>'15:09:04','cancel_start'=>'14:09:05','cancel_end'=>'15:09:05','out_time'=>'0000-00-00 00:00:00','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'1','content'=>'<p>32</p>','remark'=>NULL,'room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'5','bloc_id'=>'93','store_id'=>'3','hotel_id'=>'108','type_id'=>'24','title'=>'鸿儒堂（豪包）','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'220','unit_id'=>NULL,'thumb'=>'202312/15/41ebca07-d0b8-3aab-ba3f-a1e4053bbe28.jpg','oprice'=>'2.00','cprice'=>'2.00','mprice'=>'2.00','thumbs'=>'a:1:{i:0;s:50:"202312/15/36e4ef3f-3f7b-38d2-a442-750d749278f8.jpg";}','device'=>'','room_pid'=>'0','is_suite'=>'0','area'=>'2.00','room_num'=>'1','toilet_num'=>'1','bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'12','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'22','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'10:21:53','checkin_end'=>'11:21:53','cancel_start'=>'10:21:54','cancel_end'=>'11:21:54','out_time'=>'0000-00-00 00:00:00','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'1','content'=>'<p>1</p>','remark'=>'','room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'6','bloc_id'=>'93','store_id'=>'3','hotel_id'=>'108','type_id'=>'24','title'=>'君逸轩（小包）','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'220','unit_id'=>NULL,'thumb'=>'202312/15/3d7b2b23-7e80-3adc-86a1-e3fffe6a47f4.jpg','oprice'=>'2.00','cprice'=>'2.00','mprice'=>'2.00','thumbs'=>'a:1:{i:0;s:50:"202312/15/4de0b6f7-d30d-349c-aa2b-7c3a471de456.jpg";}','device'=>'','room_pid'=>'0','is_suite'=>'0','area'=>'2.00','room_num'=>'1','toilet_num'=>'11','bed_children'=>'2','bed_adult'=>'2','bed'=>'4','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'4','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'1','displayorder'=>'1','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'11','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'10:22:59','checkin_end'=>'11:22:59','cancel_start'=>'10:23:00','cancel_end'=>'11:23:00','out_time'=>'0000-00-00 00:00:00','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'1','content'=>'<p>1</p>','remark'=>'','room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'7','bloc_id'=>'93','store_id'=>'3','hotel_id'=>'108','type_id'=>'24','title'=>'泊云居  大包','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'220','unit_id'=>NULL,'thumb'=>'202312/15/787036e9-d836-394c-904e-9ecedeb922e5.jpg','oprice'=>'1.00','cprice'=>'1.00','mprice'=>'1.00','thumbs'=>'a:1:{i:0;s:50:"202312/15/0c66b078-9432-35cf-87cf-f4b71b88f62c.jpg";}','device'=>'','room_pid'=>'0','is_suite'=>'0','area'=>'1.00','room_num'=>'1','toilet_num'=>'1','bed_children'=>'1','bed_adult'=>'1','bed'=>'2','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'4','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'11','displayorder'=>'11','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'10:23:42','checkin_end'=>'11:23:42','cancel_start'=>'10:23:44','cancel_end'=>'11:23:44','out_time'=>'0000-00-00 00:00:00','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'1','content'=>'<p>&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/></p>','remark'=>'','room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'8','bloc_id'=>'93','store_id'=>'3','hotel_id'=>'108','type_id'=>'24','title'=>'千帆竞(中包) ','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'220','unit_id'=>NULL,'thumb'=>'202312/15/5cf74fca-c7ab-330a-aa8d-b8d1465ed0fd.jpg','oprice'=>'2.00','cprice'=>'1.00','mprice'=>'2.00','thumbs'=>'a:1:{i:0;s:50:"202312/15/dc6f65e1-ca21-3b79-aaab-ef99ce8f3ef4.jpg";}','device'=>'','room_pid'=>'0','is_suite'=>'0','area'=>'1.00','room_num'=>'1','toilet_num'=>'1','bed_children'=>'1','bed_adult'=>'1','bed'=>'2','cleaning_fee'=>'0.00','server_fee'=>NULL,'persons'=>'4','bedadd'=>'1','status'=>'1','isshow'=>'1','sales'=>'11','displayorder'=>'11','area_show'=>'1','floor_show'=>'1','smoke_show'=>'1','bed_show'=>'1','persons_show'=>'1','bedadd_show'=>'0','score'=>'1','breakfast'=>'1','language'=>'1','free_cancel'=>'1','checkin_start'=>'10:24:34','checkin_end'=>'11:24:34','cancel_start'=>'10:24:35','cancel_end'=>'11:24:35','out_time'=>'0000-00-00 00:00:00','time_length'=>NULL,'time_type'=>'0','lease_type'=>'0','desc'=>'2','content'=>'<p>12</p>','remark'=>'','room_type'=>'0','room_type_id'=>'1','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'9','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'109','type_id'=>'23','title'=>'12','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'221','unit_id'=>NULL,'thumb'=>'https://www.dandicloud.cn/attachment/202312/25/aaddadba-bc41-3317-b219-25d62473214d.jpg','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:87:"https://www.dandicloud.cn/attachment/202312/25/4cf7c215-2702-31ef-b335-764a9609e005.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>'0','toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>'10','bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>'1','breakfast'=>'0','language'=>'0','free_cancel'=>'0','checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'2','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'10','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'109','type_id'=>'23','title'=>'101','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'221','unit_id'=>NULL,'thumb'=>'https://www.dandicloud.cn/attachment/202312/25/cbef82b6-6350-3988-ad9a-e235d9ba881a.jpg','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:87:"https://www.dandicloud.cn/attachment/202312/25/b79dd2be-d367-38d9-a8e8-5798f04b461a.jpg";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>'0','toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>'5','bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>'2','displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>'1','breakfast'=>'0','language'=>'0','free_cancel'=>'0','checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'2','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'11','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'115','type_id'=>'24','title'=>'001','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'243','unit_id'=>NULL,'thumb'=>'202312/29/4d20c6df-d4c6-37ee-9a68-1664b968f3c6.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202312/29/ee3dca18-4227-3c16-b1c5-ce825ddc9c50.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>'26','room_type_id'=>'4','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'12','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'112','type_id'=>'15','title'=>'001','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'241','unit_id'=>NULL,'thumb'=>'202312/30/5c5a57cc-55c9-3748-8f74-3d92f057eed8.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202312/30/70b5fcfa-486b-3b18-a1d8-a0e6ba19ed7c.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>'18','room_type_id'=>'3','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'13','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'133','type_id'=>'22','title'=>'1-01','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'255','unit_id'=>NULL,'thumb'=>'202401/01/93255549-2a53-393e-9919-c64b7537fe95.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202401/01/a7040142-aca1-3ada-a7c0-3ec22fd4f755.png";}','device'=>NULL,'room_pid'=>'8','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'5','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'14','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'133','type_id'=>'22','title'=>'1-001','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'255','unit_id'=>NULL,'thumb'=>'202401/01/1316d17a-5b12-3330-bb0b-cefffb18f64a.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202401/01/9acaf367-1228-3925-b7cb-1a71fd977508.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'5','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'15','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'133','type_id'=>'22','title'=>'a001','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'255','unit_id'=>'8','thumb'=>'202401/01/db718968-66e4-3834-bf17-eea8d11b1bb8.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202401/01/ae297712-8b8f-35de-ab29-7c3837c97797.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'5','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'16','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'133','type_id'=>'22','title'=>'1-1-1','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'255','unit_id'=>'10','thumb'=>'202401/01/67d445f0-6c5e-3fa9-a054-e68fc457c0a3.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202401/01/9ea50695-58ff-3f34-89a0-ef6317401323.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'5','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'17','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'133','type_id'=>'22','title'=>'1-1-2','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'255','unit_id'=>'10','thumb'=>'202401/01/c6a12e76-9785-395f-99d7-f964bec6d950.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202401/01/013f4001-d974-3c05-b3f4-762dbd0a1bc0.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'5','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'18','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'133','type_id'=>'22','title'=>'f001','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'255','unit_id'=>'10','thumb'=>'202401/01/23691c67-34f7-36a0-86ff-ce59469d8148.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202401/01/cc8d38bb-8f49-3d99-84f3-6c813a635dff.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'0','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'5','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'19','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'133','type_id'=>'22','title'=>'a002','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'255','unit_id'=>'8','thumb'=>'202401/01/f44dbdef-057f-314a-b212-d0142a108eba.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202401/01/a7b127e6-7cbc-3f53-b310-6112d4ea8752.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'5','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        $this->insert('{{%diandi_place_room}}',['id'=>'20','bloc_id'=>'91','store_id'=>'153','hotel_id'=>'133','type_id'=>'22','title'=>'d001','floor'=>NULL,'bed_guest'=>NULL,'tier_id'=>'255','unit_id'=>'9','thumb'=>'202401/01/9b699563-dbc8-3c38-879f-02cba8e8c29f.png','oprice'=>'0.00','cprice'=>'0.00','mprice'=>'0.00','thumbs'=>'a:1:{i:0;s:50:"202401/01/337a3d74-1e2c-37ed-969f-29714983ce7b.png";}','device'=>NULL,'room_pid'=>'0','is_suite'=>'0','area'=>NULL,'room_num'=>NULL,'toilet_num'=>NULL,'bed_children'=>NULL,'bed_adult'=>NULL,'bed'=>'0','cleaning_fee'=>NULL,'server_fee'=>NULL,'persons'=>NULL,'bedadd'=>NULL,'status'=>'1','isshow'=>'0','sales'=>NULL,'displayorder'=>'0','area_show'=>'0','floor_show'=>'0','smoke_show'=>'0','bed_show'=>'0','persons_show'=>'0','bedadd_show'=>'0','score'=>NULL,'breakfast'=>NULL,'language'=>'0','free_cancel'=>NULL,'checkin_start'=>NULL,'checkin_end'=>NULL,'cancel_start'=>NULL,'cancel_end'=>NULL,'out_time'=>NULL,'time_length'=>'3','time_type'=>'1','lease_type'=>'1','desc'=>NULL,'content'=>NULL,'remark'=>NULL,'room_type'=>NULL,'room_type_id'=>'5','landlord_id'=>NULL,'comment_num'=>'0','comment_start'=>'5.00']);
        
        /* 设置外键约束 */
        $this->execute('SET foreign_key_checks = 1;');
    }

    public function down()
    {
        $this->execute('SET foreign_key_checks = 0');
        /* 删除表 */
        $this->dropTable('{{%diandi_place_room}}');
        $this->execute('SET foreign_key_checks = 1;');
    }
}

